﻿<!DOCTYPE html>
<html lang="en-us">
<head>
    <meta charset="utf-8">
    <title>数据调整管理</title>
    <meta name="description" content="">
    <meta name="author" content="">

    <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no">

    <!-- #CSS Links -->
    <!-- Basic Styles -->
    <link rel="stylesheet" type="text/css" media="screen" href="css/bootstrap.min.css">
    <link rel="stylesheet" type="text/css" media="screen" href="css/font-awesome.css">

    <!-- SmartAdmin Styles : Caution! DO NOT change the order -->
    <link rel="stylesheet" type="text/css" media="screen" href="css/smartadmin-production-plugins.css">
    <link rel="stylesheet" type="text/css" media="screen" href="css/smartadmin-production.css">
    <link rel="stylesheet" type="text/css" media="screen" href="css/smartadmin-skins.css">

    <!-- SmartAdmin RTL Support -->
    <link rel="stylesheet" type="text/css" media="screen" href="css/smartadmin-rtl.css">

    <!-- Demo purpose only: goes with demo.js, you can delete this css when designing your own WebApp -->
    <link rel="stylesheet" type="text/css" media="screen" href="css/demo.css">

    <!-- #FAVICONS -->
    <link rel="shortcut icon" href="img/favicon/favicon.ico" type="image/x-icon">
    <link rel="icon" href="img/favicon/favicon.ico" type="image/x-icon">

    <!-- #GOOGLE FONT -->
    <link rel="stylesheet" href="css/open-sans.css" type="text/css">

    <!-- #APP SCREEN / ICONS -->
    <link rel="apple-touch-icon" href="img/splash/sptouch-icon-iphone.png">
    <link rel="apple-touch-icon" sizes="76x76" href="img/splash/touch-icon-ipad.png">
    <link rel="apple-touch-icon" sizes="120x120" href="img/splash/touch-icon-iphone-retina.png">
    <link rel="apple-touch-icon" sizes="152x152" href="img/splash/touch-icon-ipad-retina.png">

    <!-- iOS web-app metas : hides Safari UI Components and Changes Status Bar Appearance -->
    <meta name="apple-mobile-web-app-capable" content="yes">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">

    <!-- Startup image for web apps -->
    <link rel="apple-touch-startup-image" href="img/splash/ipad-landscape.png"
        media="screen and (min-device-width: 481px) and (max-device-width: 1024px) and (orientation:landscape)">
    <link rel="apple-touch-startup-image" href="img/splash/ipad-portrait.png"
        media="screen and (min-device-width: 481px) and (max-device-width: 1024px) and (orientation:portrait)">
    <link rel="apple-touch-startup-image" href="img/splash/iphone.png" media="screen and (max-device-width: 320px)">
    <link href="appcss/Common.css" rel="stylesheet" />


</head>
<body class="desktop-detected minified">

    <!-- #MAIN PANEL -->
    <div id="main" role="main">

        <!-- RIBBON -->
        <div id="ribbon">

            <span class="ribbon-button-alignment">
                <span class="btn btn-ribbon"><i class="fa fa-home"></i></span>
            </span>

            <!-- breadcrumb -->
            <ol class="breadcrumb">
                <li><a href="DataAdjustmentManagementOne.html">数据调整管理-Step1</a></li>
                <li>数据调整管理-Step2</li>
            </ol>
            <!-- end breadcrumb -->

        </div>
        <!-- END RIBBON -->


        <!-- MAIN CONTENT -->
        <div id="content">
            <div class="row hidden">
                <div class="col-xs-12 col-sm-7 col-md-7 col-lg-4">
                    <h2 class="page-title txt-color-blueDark">
                        <i class="fa fa-table fa-fw "></i>
                        主页
               
                        <span>数据调整管理
                        </span>
                    </h2>
                </div>
            </div>

            <!-- widget grid -->
            <section id="widget-grid" class="">

                <!-- row -->
                <div class="row" style="margin-top: 8px;">

                    <!-- NEW WIDGET START -->
                    <article class="col-xs-12 col-sm-12 col-md-12 col-lg-12">
                        <!-- Widget ID (each widget will need unique ID)-->
                        <div class="jarviswidget jarviswidget-sortable" id="wid-id-0"
                            data-widget-editbutton="false">
                            <header>
                                <span class="widget-icon"><i class="fa fa-table"></i></span>
                                <h2>数据调整列表</h2>
                            </header>
                            <!-- widget div-->
                            <div>
                                <!-- end widget edit box -->
                                <!-- widget content -->
                                <div class="widget-body">

                                    <div class="table-responsive">
                                        <table class="table table-hover table-bordered smart-form" id="Table-Data">
                                            <thead>
                                                <tr>
                                                    <td>信息加载中......</td>
                                                </tr>
                                            </thead>
                                            <tbody>
                                            </tbody>
                                        </table>

                                    </div>

                                </div>
                                <!-- end widget content -->

                            </div>
                            <!-- end widget div -->

                        </div>

                        <!-- end widget -->

                    </article>
                    <!-- WIDGET END -->

                </div>

                <!-- end row -->

            </section>
            <!-- end widget grid -->
        </div>
        <!-- END MAIN CONTENT -->
    </div>

    <!-- END #MAIN CONTENT -->

    <!--================================================== -->

    <!-- PACE LOADER - turn this on if you want ajax loading to show (caution: uses lots of memory on iDevices)
<script data-pace-options='{ "restartOnRequestAfter": true }' src="js/plugin/pace/pace.min.js"></script>-->


    <!-- #PLUGINS -->
    <!-- Link to Google CDN's jQuery + jQueryUI; fall back to local -->


    <script src="js/libs/jquery-2.1.1.min.js"></script>
    <script src="js/libs/jquery-ui-1.10.3.min.js"></script>
    <!-- BOOTSTRAP JS -->
    <script src="js/bootstrap/bootstrap.min.js"></script>

    <!-- IMPORTANT: APP CONFIG -->
    <script src="js/app.config.js"></script>


    <!-- CUSTOM NOTIFICATION -->
    <script src="js/notification/SmartNotification.min.js"></script>

    <!-- JARVIS WIDGETS -->
    <script src="js/smartwidgets/jarvis.widget.min.js"></script>


    <!-- SPARKLINES -->
    <script src="js/plugin/sparkline/jquery.sparkline.min.js"></script>

    <!-- JQUERY MASKED INPUT -->
    <script src="js/plugin/masked-input/jquery.maskedinput.min.js"></script>


    <!-- JQUERY UI + Bootstrap Slider -->
    <script src="js/plugin/bootstrap-slider/bootstrap-slider.min.js"></script>
    <script src="js/plugin/datatables/jquery.dataTables.min.js"></script>
    <script src="js/plugin/datatables/dataTables.colVis.min.js"></script>
    <script src="js/plugin/datatables/dataTables.tableTools.min.js"></script>
    <script src="js/plugin/datatables/dataTables.bootstrap.min.js"></script>
    <script src="js/plugin/datatable-responsive/datatables.responsive.min.js"></script>
    <script src="appjs/Common.js"></script>
    <script src="appjs/Helper.js"></script>
    <script src="js/app.min.js"></script>
    <script>
        var draw = 0;
        var dataTableId = GetQueryString("dataTableId");
        var dataColumn = new Array();
        var idkeyname = new Array();
        $(function () {
            $("#DataAdjustmentUpdate").attr("href", $("#DataAdjustmentUpdate").attr("href") + "?Id=" + dataTableId);
            $("#DataAdjustmentRecords").attr("href", $("#DataAdjustmentRecords").attr("href") + "?Id=" + dataTableId);
            //初始化表格
            var intData = function () {
                $.ajax({
                    url: apiUrl,
                    dataType: "json",
                    data: {
                        "sys:sno": "ETL",
                        "sys:act": "GetDataTableDataList",
                        "TableId": dataTableId,
                        "Page": 0
                    },
                    success: function (result) {
                        if (result.IsSccuess) {
                            if (result.Data.PKColumns.length == 0) {
                                alert("数据表没有主键，无法进行操作");
                                window.history.back();
                            }
                            var trs = "<tr>";
                            for (var i = 0; i < result.Data.Columns.length; i++) {
                                var $this = result.Data.Columns[i];
                                if ($this == "_RowNumber") {
                                    continue;
                                } else {
                                    var state = true;
                                    for (var j = 0; j < result.Data.PKColumns.length; j++) {
                                        if (result.Data.PKColumns[j] == $this) {
                                            state = false;
                                            idkeyname.push(result.Data.PKColumns[j]);
                                            break;
                                        }
                                    }
                                    if (state) {
                                        trs += ("<th>" + $this + "</th>");
                                        dataColumn.push({ "data": $this });
                                    }

                                }
                            }
                            dataColumn.push({ data: "option" });
                            trs += ("<th>操作</th>");
                            trs += "</tr>";
                            $("#Table-Data thead").html(trs);
                            initializationDataTableForDataTable();
                        } else {
                            if (IsLogined(result.ErrorCode)) {
                                alert("失败（" + "错误代码：" + result.ErrorCode + "，错误信息：" + result.Message + ")");
                            }
                        }
                    }, error: function () {
                        alert("系统异常,请稍后重试！");
                        window.history.back();
                    }
                });
            }
            var initializationDataTableForDataTable = function () {
                $('#Table-Data').dataTable({
                    "autoWidth": true,
                    "oLanguage": dataTableConfig,
                    "bLengthChange": false,
                    ordering: false,
                    bProcessing: true,
                    bStateSave: true,
                    serverSide: true,
                    searching: false,
                    aLengthMenu: [25],
                    "ajax": {
                        url: apiUrl,
                        "dataSrc": function (json) {
                            if (json.IsSccuess) {
                                var newjson = new Array();
                                for (var i = 0; i < json.Data.Items.length; i++) {
                                    var obj = new Object();
                                    var pknamestr = "";
                                    var pkvaluestr = "";
                                    for (var j = 0; j < json.Data.Columns.length; j++) {
                                        var $this = json.Data.Columns[j];
                                        if ($this == "_RowNumber") {
                                            continue;
                                        } else {
                                            var state = true;
                                            for (var k = 0; k < idkeyname.length; k++) {
                                                if ($this == idkeyname[k]) {
                                                    state = false;
                                                    if (pknamestr == "") {
                                                        pknamestr += idkeyname[k];
                                                        pkvaluestr += json.Data.Items[i].Values[j];
                                                    } else {
                                                        pknamestr += ("," + idkeyname[k]);
                                                        pkvaluestr += ("," + json.Data.Items[i].Values[j]);
                                                    }
                                                    break;
                                                }
                                            }
                                            if (state) {
                                                obj[$this] = json.Data.Items[i].Values[j];
                                            }
                                        }
                                    }
                                    var editstr = "";
                                    editstr += "<a href=\"javascript:void(0);\" onclick=\"Update(this)\"  pknamestr=\"" + pknamestr + "\" pkvaluestr=\"" + pkvaluestr;
                                    editstr += "\"><i class=\"fa fa-pencil-square-o\"></i>修改</a>";
                                    editstr += "<a href=\"javascript:void(0);\" onclick=\"Records(this)\" pknamestr=\"" + pknamestr + "\" pkvaluestr=\"" + pkvaluestr;
                                    editstr += "\"><i class=\"fa fa-hand-o-right\"></i>查看修改记录</a>";
                                    obj["option"] = editstr;
                                    newjson.push(obj);
                                }
                                return newjson;
                            } else {
                                if (IsLogined(json.ErrorCode)) {
                                    alert("失败（" + "错误代码：" + json.ErrorCode + "，错误信息：" + json.Message + ")");
                                }
                            }
                            return [];
                        },
                        "data": function (d) {
                            draw = d.draw;
                            return $.extend({}, { "sys:sno": "ETL" }, { "sys:act": "GetDataTableDataList" }, { "TableId": dataTableId }, { "draw": d.draw }, { "length": d.length }, { "Page": parseInt(d.start / d.length) });
                        }
                    },
                    columns: dataColumn
                });
            }
            intData();
        });
        var Records = function (obj) {
            var pkname = $(obj).attr("pknamestr");
            var pkvalue = $(obj).attr("pkvaluestr");
            window.location.href = "DataAdjustmentRecords.html?pkname=" + pkname + "&pkvalue=" + pkvalue + "&dataTableId=" + dataTableId;
        }
        var Update = function (obj) {
            var pkname = $(obj).attr("pknamestr");
            var pkvalue = $(obj).attr("pkvaluestr");
            window.location.href = "DataAdjustmentUpdate.html?pkname=" + pkname + "&pkvalue=" + pkvalue + "&dataTableId=" + dataTableId;
        }

    </script>


</body>
</html>
